package DAO;

import javabean.Complaint;

import java.sql.SQLException;
import java.util.List;

public interface IComplaintDAO {
    public List<Complaint> getAllComplaint() throws SQLException;
    public List<Complaint> getAllUnassignedComplaint() throws SQLException;
    public List<Complaint> getAllComplaintByCustomerID(String customerID) throws SQLException;
    public List<Complaint> getAllUnassignedComplaintByCustomerID(String customerID) throws SQLException;
    public List<Complaint> getAllComplaintByStaffID(String staffID) throws SQLException;
    public boolean addUnassignedComplaint(Complaint complaint) throws SQLException;
    public boolean addComplaint(int ComplaintID, String StaffID) throws SQLException;
    public boolean deleteComplaint(int complaintID) throws SQLException;
    public boolean updateComplaint(Complaint complaint) throws SQLException;
    public Complaint getComplaintByID(int complaintID) throws SQLException;
    public Complaint getComplaintByOrderID(int orderID) throws SQLException;
    public boolean evaluateComplaint(int ComplaintID, String Evaluation) throws SQLException;
}
